Comparing Prior Order Profile Report and Train Order Profile Report

Dataset statistics

	Prior Order Profile Report	Train Order Profile Report
Number of variables	10	10
Number of observations	32434489	1384617
Missing cells	2078068	0
Missing cells (%)	0.6%	0.0%
Duplicate rows	0	0
Duplicate rows (%)	0.0%	0.0%
Total size in memory	2.4 GiB	105.6 MiB
Average record size in memory	80.0 B	80.0 B

Variable types

	Prior Order Profile Report	Train Order Profile Report
Numeric	8	8
Categorical	2	2

Alerts

Prior Order Profile Report	Train Order Profile Report
`eval_set` has constant value "prior"	`eval_set` has constant value "train"	Constant
`days_since_prior_order` has 2078068 (6.4%) missing values	Alert not present in this dataset	Missing
`order_dow` has 6209666 (19.1%) zeros	`order_dow` has 324026 (23.4%) zeros	Zeros
`days_since_prior_order` has 448698 (1.4%) zeros	`days_since_prior_order` has 17044 (1.2%) zeros	Zeros

Reproduction

	Prior Order Profile Report	Train Order Profile Report
Analysis started	2024-11-01 20:57:22.573259	2024-11-01 21:07:35.426262
Analysis finished	2024-11-01 21:07:29.668437	2024-11-01 21:08:03.001191
Duration	10 minutes and 7.1 seconds	27.57 seconds
Software version	ydata-profiling v0.0.dev0	ydata-profiling v0.0.dev0
Download configuration	config.json	config.json

order_id
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	3214874	131209
Distinct (%)	9.9%	9.5%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	1710748.5	1706297.6

	Prior Order Profile Report	Train Order Profile Report
Minimum	2	1
Maximum	3421083	3421070
Zeros	0	0
Zeros (%)	0.0%	0.0%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	2	1
5-th percentile	170925	170761
Q1	855943	843370
median	1711048	1701880
Q3	2565514	2568023
95-th percentile	3250209	3249514.2
Maximum	3421083	3421070
Range	3421081	3421069
Interquartile range (IQR)	1709571	1724653

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	987300.7	989732.65
Coefficient of variation (CV)	0.57711621	0.5800469
Kurtosis	-1.1991283	-1.2066256
Mean	1710748.5	1706297.6
Median Absolute Deviation (MAD)	854783	861914
Skewness	-0.00048974146	0.0063315648
Sum	5.5487254 × 10¹³	2.3625687 × 10¹²
Variance	9.7476267 × 10¹¹	9.7957072 × 10¹¹
Monotonicity	Increasing	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1564244	145	< 0.1%
790903	137	< 0.1%
61355	127	< 0.1%
2970392	121	< 0.1%
2069920	116	< 0.1%
3308010	115	< 0.1%
2753324	114	< 0.1%
2499774	112	< 0.1%
2621625	109	< 0.1%
77151	109	< 0.1%
Other values (3214864)	32433284	> 99.9%

Value	Count	Frequency (%)
1395075	80	< 0.1%
2813632	80	< 0.1%
949182	77	< 0.1%
2869702	76	< 0.1%
341238	76	< 0.1%
312611	75	< 0.1%
1465173	74	< 0.1%
1355077	74	< 0.1%
653280	72	< 0.1%
288915	72	< 0.1%
Other values (131199)	1383861	99.9%

Value	Count	Frequency (%)
2	9	< 0.1%
3	8	< 0.1%
4	13	< 0.1%
5	26	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
9	15	< 0.1%
10	15	< 0.1%
11	5	< 0.1%

Value	Count	Frequency (%)
1	8	< 0.1%
36	8	< 0.1%
38	9	< 0.1%
96	7	< 0.1%
98	49	< 0.1%
112	11	< 0.1%
170	17	< 0.1%
218	5	< 0.1%
226	13	< 0.1%
349	11	< 0.1%

Value	Count	Frequency (%)
1	8	< 0.1%
36	8	< 0.1%
38	9	< 0.1%
96	7	< 0.1%
98	49	< 0.1%
112	11	< 0.1%
170	17	< 0.1%
218	5	< 0.1%
226	13	< 0.1%
349	11	< 0.1%

Value	Count	Frequency (%)
2	9	< 0.1%
3	8	< 0.1%
4	13	< 0.1%
5	26	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
9	15	< 0.1%
10	15	< 0.1%
11	5	< 0.1%

product_id
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	49677	39123
Distinct (%)	0.2%	2.8%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	25576.338	25556.236

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	1
Maximum	49688	49688
Zeros	0	0
Zeros (%)	0.0%	0.0%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	1
5-th percentile	3376	3397
Q1	13530	13380
median	25256	25298
Q3	37935	37940
95-th percentile	47559	47601
Maximum	49688	49688
Range	49687	49687
Interquartile range (IQR)	24405	24560

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	14096.689	14121.272
Coefficient of variation (CV)	0.55116136	0.55255682
Kurtosis	-1.1408165	-1.1537944
Mean	25576.338	25556.236
Median Absolute Deviation (MAD)	12080	12122
Skewness	-0.021130583	-0.022354791
Sum	8.2955544 × 10¹¹	3.5385598 × 10¹⁰
Variance	1.9871664 × 10⁸	1.9941034 × 10⁸
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24852	472565	1.5%
13176	379450	1.2%
21137	264683	0.8%
21903	241921	0.7%
47209	213584	0.7%
47766	176815	0.5%
47626	152657	0.5%
16797	142951	0.4%
26209	140627	0.4%
27845	137905	0.4%
Other values (49667)	30111331	92.8%

Value	Count	Frequency (%)
24852	18726	1.4%
13176	15480	1.1%
21137	10894	0.8%
21903	9784	0.7%
47626	8135	0.6%
47766	7409	0.5%
47209	7293	0.5%
16797	6494	0.5%
26209	6033	0.4%
27966	5546	0.4%
Other values (39113)	1288823	93.1%

Value	Count	Frequency (%)
1	1852	< 0.1%
2	90	< 0.1%
3	277	< 0.1%
4	329	< 0.1%
5	15	< 0.1%
6	8	< 0.1%
7	30	< 0.1%
8	165	< 0.1%
9	156	< 0.1%
10	2572	< 0.1%

Value	Count	Frequency (%)
1	76	< 0.1%
2	4	< 0.1%
3	6	< 0.1%
4	22	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	13	< 0.1%
9	5	< 0.1%
10	119	< 0.1%
11	2	< 0.1%

Value	Count	Frequency (%)
1	76	< 0.1%
2	4	< 0.1%
3	6	< 0.1%
4	22	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	13	< 0.1%
9	5	< 0.1%
10	119	< 0.1%
11	2	< 0.1%

Value	Count	Frequency (%)
1	1852	0.1%
2	90	< 0.1%
3	277	< 0.1%
4	329	< 0.1%
5	15	< 0.1%
6	8	< 0.1%
7	30	< 0.1%
8	165	< 0.1%
9	156	< 0.1%
10	2572	0.2%

add_to_cart_order
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	145	80
Distinct (%)	< 0.1%	< 0.1%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	8.3510755	8.7580443

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	1
Maximum	145	80
Zeros	0	0
Zeros (%)	0.0%	0.0%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	1
5-th percentile	1	1
Q1	3	3
median	6	7
Q3	11	12
95-th percentile	22	23
Maximum	145	80
Range	144	79
Interquartile range (IQR)	8	9

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	7.1266712	7.4239365
Coefficient of variation (CV)	0.85338363	0.84767058
Kurtosis	5.643873	4.1722265
Mean	8.3510755	8.7580443
Median Absolute Deviation (MAD)	4	4
Skewness	1.8180712	1.6855488
Sum	2.7086287 × 10⁸	12126537
Variance	50.789442	55.114833
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3214874	9.9%
2	3058126	9.4%
3	2871133	8.9%
4	2664106	8.2%
5	2442025	7.5%
6	2213695	6.8%
7	1986020	6.1%
8	1766014	5.4%
9	1562640	4.8%
10	1378293	4.2%
Other values (135)	9277563	28.6%

Value	Count	Frequency (%)
1	131209	9.5%
2	124364	9.0%
3	116996	8.4%
4	108963	7.9%
5	100745	7.3%
6	91850	6.6%
7	83142	6.0%
8	74601	5.4%
9	66618	4.8%
10	59401	4.3%
Other values (70)	426728	30.8%

Value	Count	Frequency (%)
1	3214874	9.9%
2	3058126	9.4%
3	2871133	8.9%
4	2664106	8.2%
5	2442025	7.5%
6	2213695	6.8%
7	1986020	6.1%
8	1766014	5.4%
9	1562640	4.8%
10	1378293	4.2%

Value	Count	Frequency (%)
1	131209	9.5%
2	124364	9.0%
3	116996	8.4%
4	108963	7.9%
5	100745	7.3%
6	91850	6.6%
7	83142	6.0%
8	74601	5.4%
9	66618	4.8%
10	59401	4.3%

Value	Count	Frequency (%)
1	131209	0.4%
2	124364	0.4%
3	116996	0.4%
4	108963	0.3%
5	100745	0.3%
6	91850	0.3%
7	83142	0.3%
8	74601	0.2%
9	66618	0.2%
10	59401	0.2%

Value	Count	Frequency (%)
1	3214874	232.2%
2	3058126	220.9%
3	2871133	207.4%
4	2664106	192.4%
5	2442025	176.4%
6	2213695	159.9%
7	1986020	143.4%
8	1766014	127.5%
9	1562640	112.9%
10	1378293	99.5%

reordered
Categorical

	Prior Order Profile Report	Train Order Profile Report
Distinct	2	2
Distinct (%)	< 0.1%	< 0.1%
Missing	0	0
Missing (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

1	19126536
0	13307953

1	828824
0	555793

Length

	Prior Order Profile Report	Train Order Profile Report
Max length	1	1
Median length	1	1
Mean length	1	1
Min length	1	1

Characters and Unicode

	Prior Order Profile Report	Train Order Profile Report
Total characters	32434489	1384617
Distinct characters	2	2
Distinct categories	1	1 ?
Distinct scripts	1	1 ?
Distinct blocks	1	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

	Prior Order Profile Report	Train Order Profile Report
Unique	0	0 ?
Unique (%)	0.0%	0.0%

Sample

	Prior Order Profile Report	Train Order Profile Report
1st row	1	1
2nd row	1	1
3rd row	0	0
4th row	1	0
5th row	0	1

Common Values

Value	Count	Frequency (%)
1	19126536	59.0%
0	13307953	41.0%

Value	Count	Frequency (%)
1	828824	59.9%
0	555793	40.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Prior Order Profile Report

Train Order Profile Report

Value	Count	Frequency (%)
1	19126536	59.0%
0	13307953	41.0%

Value	Count	Frequency (%)
1	828824	59.9%
0	555793	40.1%

Most occurring characters

Value	Count	Frequency (%)
1	19126536	59.0%
0	13307953	41.0%

Value	Count	Frequency (%)
1	828824	59.9%
0	555793	40.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32434489	100.0%

Value	Count	Frequency (%)
(unknown)	1384617	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	19126536	59.0%
0	13307953	41.0%

Value	Count	Frequency (%)
1	828824	59.9%
0	555793	40.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32434489	100.0%

Value	Count	Frequency (%)
(unknown)	1384617	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	19126536	59.0%
0	13307953	41.0%

Value	Count	Frequency (%)
1	828824	59.9%
0	555793	40.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32434489	100.0%

Value	Count	Frequency (%)
(unknown)	1384617	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	19126536	59.0%
0	13307953	41.0%

Value	Count	Frequency (%)
1	828824	59.9%
0	555793	40.1%

user_id
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	206209	131209
Distinct (%)	0.6%	9.5%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	102937.24	103112.78

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	1
Maximum	206209	206209
Zeros	0	0
Zeros (%)	0.0%	0.0%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	1
5-th percentile	10469	10425
Q1	51421	51732
median	102611	102933
Q3	154391	154959
95-th percentile	195736	195696
Maximum	206209	206209
Range	206208	206208
Interquartile range (IQR)	102970	103227

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	59466.478	59487.148
Coefficient of variation (CV)	0.57769645	0.57691342
Kurtosis	-1.2009235	-1.2007212
Mean	102937.24	103112.78
Median Absolute Deviation (MAD)	51493	51608
Skewness	0.0066119537	-0.0003274701
Sum	3.3387168 × 10¹²	1.4277171 × 10¹¹
Variance	3.536262 × 10⁹	3.5387208 × 10⁹
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201268	3725	< 0.1%
129928	3638	< 0.1%
164055	3061	< 0.1%
186704	2936	< 0.1%
176478	2921	< 0.1%
182401	2907	< 0.1%
137629	2901	< 0.1%
33731	2888	< 0.1%
108187	2760	< 0.1%
4694	2735	< 0.1%
Other values (206199)	32404017	99.9%

Value	Count	Frequency (%)
197541	80	< 0.1%
149753	80	< 0.1%
63458	77	< 0.1%
83993	76	< 0.1%
189951	76	< 0.1%
169647	75	< 0.1%
31611	74	< 0.1%
104741	74	< 0.1%
181991	72	< 0.1%
59321	72	< 0.1%
Other values (131199)	1383861	99.9%

Value	Count	Frequency (%)
1	59	< 0.1%
2	195	< 0.1%
3	88	< 0.1%
4	18	< 0.1%
5	37	< 0.1%
6	14	< 0.1%
7	206	< 0.1%
8	49	< 0.1%
9	76	< 0.1%
10	143	< 0.1%

Value	Count	Frequency (%)
1	11	< 0.1%
2	31	< 0.1%
5	9	< 0.1%
7	9	< 0.1%
8	18	< 0.1%
9	22	< 0.1%
10	4	< 0.1%
13	5	< 0.1%
14	11	< 0.1%
17	6	< 0.1%

Value	Count	Frequency (%)
1	11	< 0.1%
2	31	< 0.1%
5	9	< 0.1%
7	9	< 0.1%
8	18	< 0.1%
9	22	< 0.1%
10	4	< 0.1%
13	5	< 0.1%
14	11	< 0.1%
17	6	< 0.1%

Value	Count	Frequency (%)
1	59	< 0.1%
2	195	< 0.1%
3	88	< 0.1%
4	18	< 0.1%
5	37	< 0.1%
6	14	< 0.1%
7	206	< 0.1%
8	49	< 0.1%
9	76	< 0.1%
10	143	< 0.1%

eval_set
Categorical

	Prior Order Profile Report	Train Order Profile Report
Distinct	1	1
Distinct (%)	< 0.1%	< 0.1%
Missing	0	0
Missing (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

prior	32434489

train	1384617

Length

	Prior Order Profile Report	Train Order Profile Report
Max length	5	5
Median length	5	5
Mean length	5	5
Min length	5	5

Characters and Unicode

	Prior Order Profile Report	Train Order Profile Report
Total characters	162172445	6923085
Distinct characters	4	5
Distinct categories	1	1 ?
Distinct scripts	1	1 ?
Distinct blocks	1	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

	Prior Order Profile Report	Train Order Profile Report
Unique	0	0 ?
Unique (%)	0.0%	0.0%

Sample

	Prior Order Profile Report	Train Order Profile Report
1st row	prior	train
2nd row	prior	train
3rd row	prior	train
4th row	prior	train
5th row	prior	train

Common Values

Value	Count	Frequency (%)
prior	32434489	100.0%

Value	Count	Frequency (%)
train	1384617	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Prior Order Profile Report

Train Order Profile Report

Value	Count	Frequency (%)
prior	32434489	100.0%

Value	Count	Frequency (%)
train	1384617	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	64868978	40.0%
p	32434489	20.0%
i	32434489	20.0%
o	32434489	20.0%

Value	Count	Frequency (%)
t	1384617	20.0%
r	1384617	20.0%
a	1384617	20.0%
i	1384617	20.0%
n	1384617	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	162172445	100.0%

Value	Count	Frequency (%)
(unknown)	6923085	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	64868978	40.0%
p	32434489	20.0%
i	32434489	20.0%
o	32434489	20.0%

Value	Count	Frequency (%)
t	1384617	20.0%
r	1384617	20.0%
a	1384617	20.0%
i	1384617	20.0%
n	1384617	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	162172445	100.0%

Value	Count	Frequency (%)
(unknown)	6923085	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	64868978	40.0%
p	32434489	20.0%
i	32434489	20.0%
o	32434489	20.0%

Value	Count	Frequency (%)
t	1384617	20.0%
r	1384617	20.0%
a	1384617	20.0%
i	1384617	20.0%
n	1384617	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	162172445	100.0%

Value	Count	Frequency (%)
(unknown)	6923085	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	64868978	40.0%
p	32434489	20.0%
i	32434489	20.0%
o	32434489	20.0%

Value	Count	Frequency (%)
t	1384617	20.0%
r	1384617	20.0%
a	1384617	20.0%
i	1384617	20.0%
n	1384617	20.0%

order_number
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	99	97
Distinct (%)	< 0.1%	< 0.1%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	17.14205	17.09141

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	4
Maximum	99	100
Zeros	0	0
Zeros (%)	0.0%	0.0%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	1	4
5-th percentile	1	4
Q1	5	6
median	11	11
Q3	24	21
95-th percentile	54	52
Maximum	99	100
Range	98	96
Interquartile range (IQR)	19	15

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	17.53504	16.614037
Coefficient of variation (CV)	1.0229255	0.97206939
Kurtosis	3.256605	5.8967139
Mean	17.14205	17.09141
Median Absolute Deviation (MAD)	8	6
Skewness	1.7568963	2.2433716
Sum	5.5599364 × 10⁸	23665057
Variance	307.47765	276.02621
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2078068	6.4%
3	2050731	6.3%
2	2048332	6.3%
4	1820298	5.6%
5	1628411	5.0%
6	1472238	4.5%
7	1333847	4.1%
8	1219148	3.8%
9	1120468	3.5%
10	1028704	3.2%
Other values (89)	16634244	51.3%

Value	Count	Frequency (%)
4	149882	10.8%
5	123548	8.9%
6	105328	7.6%
7	90949	6.6%
8	75645	5.5%
9	68366	4.9%
10	60216	4.3%
11	51530	3.7%
12	47819	3.5%
13	42072	3.0%
Other values (87)	569262	41.1%

Value	Count	Frequency (%)
1	2078068	6.4%
2	2048332	6.3%
3	2050731	6.3%
4	1820298	5.6%
5	1628411	5.0%
6	1472238	4.5%
7	1333847	4.1%
8	1219148	3.8%
9	1120468	3.5%
10	1028704	3.2%

Value	Count	Frequency (%)
4	149882	10.8%
5	123548	8.9%
6	105328	7.6%
7	90949	6.6%
8	75645	5.5%
9	68366	4.9%
10	60216	4.3%
11	51530	3.7%
12	47819	3.5%
13	42072	3.0%

Value	Count	Frequency (%)
4	149882	0.5%
5	123548	0.4%
6	105328	0.3%
7	90949	0.3%
8	75645	0.2%
9	68366	0.2%
10	60216	0.2%
11	51530	0.2%
12	47819	0.1%
13	42072	0.1%

Value	Count	Frequency (%)
1	2078068	150.1%
2	2048332	147.9%
3	2050731	148.1%
4	1820298	131.5%
5	1628411	117.6%
6	1472238	106.3%
7	1333847	96.3%
8	1219148	88.0%
9	1120468	80.9%
10	1028704	74.3%

order_dow
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	7	7
Distinct (%)	< 0.1%	< 0.1%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	2.7388177	2.7013918

	Prior Order Profile Report	Train Order Profile Report
Minimum	0	0
Maximum	6	6
Zeros	6209666	324026
Zeros (%)	19.1%	23.4%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	0	0
5-th percentile	0	0
Q1	1	1
median	3	3
Q3	5	5
95-th percentile	6	6
Maximum	6	6
Range	6	6
Interquartile range (IQR)	4	4

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	2.0900491	2.1676456
Coefficient of variation (CV)	0.76312092	0.80241809
Kurtosis	-1.3339893	-1.3989458
Mean	2.7388177	2.7013918
Median Absolute Deviation (MAD)	2	2
Skewness	0.18019293	0.1755159
Sum	88832152	3740393
Variance	4.3683052	4.6986876
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	6209666	19.1%
1	5665856	17.5%
6	4500304	13.9%
2	4217798	13.0%
5	4209533	13.0%
3	3844117	11.9%
4	3787215	11.7%

Value	Count	Frequency (%)
0	324026	23.4%
6	207279	15.0%
1	205978	14.9%
5	176910	12.8%
2	160562	11.6%
4	155481	11.2%
3	154381	11.1%

Value	Count	Frequency (%)
0	6209666	19.1%
1	5665856	17.5%
2	4217798	13.0%
3	3844117	11.9%
4	3787215	11.7%
5	4209533	13.0%
6	4500304	13.9%

Value	Count	Frequency (%)
0	324026	23.4%
1	205978	14.9%
2	160562	11.6%
3	154381	11.1%
4	155481	11.2%
5	176910	12.8%
6	207279	15.0%

Value	Count	Frequency (%)
0	324026	1.0%
1	205978	0.6%
2	160562	0.5%
3	154381	0.5%
4	155481	0.5%
5	176910	0.5%
6	207279	0.6%

Value	Count	Frequency (%)
0	6209666	448.5%
1	5665856	409.2%
2	4217798	304.6%
3	3844117	277.6%
4	3787215	273.5%
5	4209533	304.0%
6	4500304	325.0%

order_hour_of_day
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	24	24
Distinct (%)	< 0.1%	< 0.1%
Missing	0	0
Missing (%)	0.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	13.424977	13.577592

	Prior Order Profile Report	Train Order Profile Report
Minimum	0	0
Maximum	23	23
Zeros	218948	9083
Zeros (%)	0.7%	0.7%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	0	0
5-th percentile	7	7
Q1	10	10
median	13	14
Q3	16	17
95-th percentile	21	21
Maximum	23	23
Range	23	23
Interquartile range (IQR)	6	7

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	4.246365	4.238458
Coefficient of variation (CV)	0.31630333	0.31216566
Kurtosis	-0.011657572	0.043845727
Mean	13.424977	13.577592
Median Absolute Deviation (MAD)	3	3
Skewness	-0.044082776	-0.12102981
Sum	4.3543228 × 10⁸	18799765
Variance	18.031616	17.964526
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
10	2764426	8.5%
11	2738582	8.4%
14	2691548	8.3%
15	2664533	8.2%
13	2663292	8.2%
12	2620847	8.1%
16	2537458	7.8%
9	2456713	7.6%
17	2089465	6.4%
8	1719973	5.3%
Other values (14)	7487652	23.1%

Value	Count	Frequency (%)
14	119370	8.6%
15	116198	8.4%
13	114762	8.3%
11	114119	8.2%
12	111752	8.1%
10	110479	8.0%
16	110237	8.0%
17	96944	7.0%
9	93856	6.8%
18	76522	5.5%
Other values (14)	320378	23.1%

Value	Count	Frequency (%)
0	218948	0.7%
1	115786	0.4%
2	69434	0.2%
3	51321	0.2%
4	53283	0.2%
5	88062	0.3%
6	290795	0.9%
7	891937	2.7%
8	1719973	5.3%
9	2456713	7.6%

Value	Count	Frequency (%)
0	9083	0.7%
1	5626	0.4%
2	3226	0.2%
3	2438	0.2%
4	2431	0.2%
5	3847	0.3%
6	11847	0.9%
7	36302	2.6%
8	67386	4.9%
9	93856	6.8%

Value	Count	Frequency (%)
0	9083	< 0.1%
1	5626	< 0.1%
2	3226	< 0.1%
3	2438	< 0.1%
4	2431	< 0.1%
5	3847	< 0.1%
6	11847	< 0.1%
7	36302	0.1%
8	67386	0.2%
9	93856	0.3%

Value	Count	Frequency (%)
0	218948	15.8%
1	115786	8.4%
2	69434	5.0%
3	51321	3.7%
4	53283	3.8%
5	88062	6.4%
6	290795	21.0%
7	891937	64.4%
8	1719973	124.2%
9	2456713	177.4%

days_since_prior_order
Real number (ℝ)

	Prior Order Profile Report	Train Order Profile Report
Distinct	31	31
Distinct (%)	< 0.1%	< 0.1%
Missing	2078068	0
Missing (%)	6.4%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	11.104074	17.066126

	Prior Order Profile Report	Train Order Profile Report
Minimum	0	0
Maximum	30	30
Zeros	448698	17044
Zeros (%)	1.4%	1.2%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	247.5 MiB	10.6 MiB

Quantile statistics

	Prior Order Profile Report	Train Order Profile Report
Minimum	0	0
5-th percentile	2	3
Q1	5	7
median	8	15
Q3	15	30
95-th percentile	30	30
Maximum	30	30
Range	30	30
Interquartile range (IQR)	10	23

Descriptive statistics

	Prior Order Profile Report	Train Order Profile Report
Standard deviation	8.7789143	10.426418
Coefficient of variation (CV)	0.79060299	0.61094228
Kurtosis	-0.068967377	-1.5712889
Mean	11.104074	17.066126
Median Absolute Deviation (MAD)	4	9
Skewness	1.0539722	0.074891246
Sum	3.3707995 × 10⁸	23630048
Variance	77.069337	108.71019
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
7	3479504	10.7%
30	3070057	9.5%
6	2519939	7.8%
5	2126420	6.6%
4	2080560	6.4%
8	1933815	6.0%
3	1877881	5.8%
2	1464875	4.5%
9	1218973	3.8%
14	1030605	3.2%
Other values (21)	9553792	29.5%
(Missing)	2078068	6.4%

Value	Count	Frequency (%)
30	407265	29.4%
7	106801	7.7%
6	72138	5.2%
8	61821	4.5%
5	54117	3.9%
14	51690	3.7%
4	45727	3.3%
9	43410	3.1%
13	39081	2.8%
3	36550	2.6%
Other values (21)	466017	33.7%

Value	Count	Frequency (%)
0	448698	1.4%
1	941116	2.9%
2	1464875	4.5%
3	1877881	5.8%
4	2080560	6.4%
5	2126420	6.6%
6	2519939	7.8%
7	3479504	10.7%
8	1933815	6.0%
9	1218973	3.8%

Value	Count	Frequency (%)
0	17044	1.2%
1	19265	1.4%
2	27504	2.0%
3	36550	2.6%
4	45727	3.3%
5	54117	3.9%
6	72138	5.2%
7	106801	7.7%
8	61821	4.5%
9	43410	3.1%

Value	Count	Frequency (%)
0	17044	0.1%
1	19265	0.1%
2	27504	0.1%
3	36550	0.1%
4	45727	0.1%
5	54117	0.2%
6	72138	0.2%
7	106801	0.3%
8	61821	0.2%
9	43410	0.1%

Value	Count	Frequency (%)
0	448698	32.4%
1	941116	68.0%
2	1464875	105.8%
3	1877881	135.6%
4	2080560	150.3%
5	2126420	153.6%
6	2519939	182.0%
7	3479504	251.3%
8	1933815	139.7%
9	1218973	88.0%

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

	add_to_cart_order	days_since_prior_order	order_dow	order_hour_of_day	order_id	order_number	product_id	reordered	user_id
add_to_cart_order	1.000	0.078	-0.015	-0.015	-0.000	0.000	0.009	0.096	0.000
days_since_prior_order	0.078	1.000	-0.043	-0.004	-0.000	-0.385	0.001	0.140	0.000
order_dow	-0.015	-0.043	1.000	0.012	0.001	0.015	-0.003	0.018	-0.002
order_hour_of_day	-0.015	-0.004	0.012	1.000	0.001	-0.048	0.001	0.038	0.000
order_id	-0.000	-0.000	0.001	0.001	1.000	-0.000	-0.000	0.001	-0.000
order_number	0.000	-0.385	0.015	-0.048	-0.000	1.000	-0.002	0.341	-0.001
product_id	0.009	0.001	-0.003	0.001	-0.000	-0.002	1.000	0.040	0.000
reordered	0.096	0.140	0.018	0.038	0.001	0.341	0.040	1.000	0.004
user_id	0.000	0.000	-0.002	0.000	-0.000	-0.001	0.000	0.004	1.000

Train Order Profile Report

	add_to_cart_order	days_since_prior_order	order_dow	order_hour_of_day	order_id	order_number	product_id	reordered	user_id
add_to_cart_order	1.000	0.018	-0.024	-0.010	0.002	0.031	0.007	0.137	-0.000
days_since_prior_order	0.018	1.000	-0.025	0.008	0.003	-0.387	0.001	0.166	0.004
order_dow	-0.024	-0.025	1.000	0.009	0.001	0.015	-0.004	0.017	-0.006
order_hour_of_day	-0.010	0.008	0.009	1.000	-0.003	-0.035	0.002	0.034	-0.001
order_id	0.002	0.003	0.001	-0.003	1.000	0.002	-0.001	0.004	-0.001
order_number	0.031	-0.387	0.015	-0.035	0.002	1.000	-0.001	0.237	-0.005
product_id	0.007	0.001	-0.004	0.002	-0.001	-0.001	1.000	0.042	-0.001
reordered	0.137	0.166	0.017	0.034	0.004	0.237	0.042	1.000	0.006
user_id	-0.000	0.004	-0.006	-0.001	-0.001	-0.005	-0.001	0.006	1.000

Prior Order Profile Report

A simple visualization of nullity by column.

Train Order Profile Report

A simple visualization of nullity by column.

Prior Order Profile Report

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Train Order Profile Report

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Prior Order Profile Report

	order_id	product_id	add_to_cart_order	reordered	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order
0	2	33120	1	1	202279	prior	3	5	9	8.0
1	2	28985	2	1	202279	prior	3	5	9	8.0
2	2	9327	3	0	202279	prior	3	5	9	8.0
3	2	45918	4	1	202279	prior	3	5	9	8.0
4	2	30035	5	0	202279	prior	3	5	9	8.0
5	2	17794	6	1	202279	prior	3	5	9	8.0
6	2	40141	7	1	202279	prior	3	5	9	8.0
7	2	1819	8	1	202279	prior	3	5	9	8.0
8	2	43668	9	0	202279	prior	3	5	9	8.0
9	3	33754	1	1	205970	prior	16	5	17	12.0

Train Order Profile Report

	order_id	product_id	add_to_cart_order	reordered	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order
0	1	49302	1	1	112108	train	4	4	10	9.0
1	1	11109	2	1	112108	train	4	4	10	9.0
2	1	10246	3	0	112108	train	4	4	10	9.0
3	1	49683	4	0	112108	train	4	4	10	9.0
4	1	43633	5	1	112108	train	4	4	10	9.0
5	1	13176	6	0	112108	train	4	4	10	9.0
6	1	47209	7	0	112108	train	4	4	10	9.0
7	1	22035	8	1	112108	train	4	4	10	9.0
8	36	39612	1	0	79431	train	23	6	18	30.0
9	36	19660	2	1	79431	train	23	6	18	30.0

Prior Order Profile Report

	order_id	product_id	add_to_cart_order	reordered	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order
32434479	3421083	7854	1	0	25247	prior	24	2	6	21.0
32434480	3421083	45309	2	0	25247	prior	24	2	6	21.0
32434481	3421083	21162	3	0	25247	prior	24	2	6	21.0
32434482	3421083	18176	4	1	25247	prior	24	2	6	21.0
32434483	3421083	35211	5	0	25247	prior	24	2	6	21.0
32434484	3421083	39678	6	1	25247	prior	24	2	6	21.0
32434485	3421083	11352	7	0	25247	prior	24	2	6	21.0
32434486	3421083	4600	8	0	25247	prior	24	2	6	21.0
32434487	3421083	24852	9	1	25247	prior	24	2	6	21.0
32434488	3421083	5020	10	1	25247	prior	24	2	6	21.0

Train Order Profile Report

	order_id	product_id	add_to_cart_order	reordered	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order
1384607	3421058	30316	6	1	136952	train	20	3	18	15.0
1384608	3421058	35578	7	0	136952	train	20	3	18	15.0
1384609	3421058	32650	8	1	136952	train	20	3	18	15.0
1384610	3421063	49235	1	1	169679	train	30	0	10	4.0
1384611	3421063	13565	2	1	169679	train	30	0	10	4.0
1384612	3421063	14233	3	1	169679	train	30	0	10	4.0
1384613	3421063	35548	4	1	169679	train	30	0	10	4.0
1384614	3421070	35951	1	1	139822	train	15	6	10	8.0
1384615	3421070	16953	2	1	139822	train	15	6	10	8.0
1384616	3421070	4724	3	1	139822	train	15	6	10	8.0

Prior Order Profile Report

	order_id	product_id	add_to_cart_order	reordered	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order	# duplicates
Dataset does not contain duplicate rows.

Train Order Profile Report

	order_id	product_id	add_to_cart_order	reordered	user_id	eval_set	order_number	order_dow	order_hour_of_day	days_since_prior_order	# duplicates
Dataset does not contain duplicate rows.

Overview

Variables

Common Values

Length

Common Values (Plot)

Prior Order Profile Report

Train Order Profile Report

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Prior Order Profile Report

Train Order Profile Report

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report

Train Order Profile Report

Prior Order Profile Report